package com.neusoft.work.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.neusoft.work.po.RoomInfo;

public interface RoomInfoDao extends BaseMapper<RoomInfo> {
	@Select("select roomNumber from roomInfo")
	List<String> selectRoomNumber();
	
	@Select("select roomNumber from roomInfo where floor = #{floor}")
	List<String> selectRoomNumberByFloor(Integer floor);
	
	@Select("select usageType from roomInfo where roomNumber = #{roomNumber}")
	Integer selectUsageTypeByRoomNumber(String roomNumber);
	
	@Select("select * from roomInfo where floor = #{floor} order by roomNumber")
	List<RoomInfo> selectRoomsByFloor(Integer floor);
}
